﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

namespace MockPrjTeam2.Entity
{
    public class PremiseInfor
    {
        private string _PremiseID;
        private string _AddressID;
        private string _CountryID;
        private string _OrgID;
        private string _LocationStatusID;
        private string _LocationStatusDate;
        private string _CityTown;
        private string _Country;
        private string _LocationTypeID;
        private string _LocationTypeDescription;
        private string _PhoneNumber;
        private string _GeneralFaxNumber;
        private string _MiniCommNumber;
        private string _ShopFlagDate;
        private string _SpecialistShop;
        private string _Accreditations;
        private string _ContacID;
        private string _LocalDemographicIssues;
        private string _LocalDemographicNotes;
        private string _JSPOffices;
        private string _CateringTypeID;
        private string _IsNetwork;
        private string _ClientITFacilitiesDetails;
        private string _RoomAvailability;
        private string _VolunteeringOpportunies;
        private string _OutreachLocation;
        private string _TravelDetails;
        private string _TravelNearestBus;
        private string _TravelNearestRail;
        private string _TravelNearesAirport;
        private string _LocalHotels;
        private string _VisitorParkingOnsite;
        private string _VisitorParkingSpace;
        private string _VisitorParkingAlternative;
        private string _RoomOnlyRate;
        private string _BBRate;
        private string _DBBRate;
        private string _DDRate;
        private string _24hrRate;
        private string _TeaCoffee;
        private string _Lunch;
        private string _NoOfMeetingRooms;
        private string _MeetingRoomRatePerDay;
        private string _Coding;
        private string _NegotiatedRoomOnlyRate;
        private string _BBNegotiatedRate;
        private string _DBBNegotiatedRate;
        private string _24hrNegotiatedRate;
        private string _LastNegotiatedDate;
        private string _ReNegotiatedOn;
        private string _PreferredStatus;
        private string _Comment;
        private string _IsActive;

        public string PremiseID { get; set; }
        public string AddressID { get; set; }
        public string CountryID { get; set; }
        public string OrgID { get; set; }
        public string LocationStatusID { get; set; }
        public string LocationStatusDate { get; set; }
        public string CityTown { get; set; }
        public string Country { get; set; }
        public string LocationTypeID { get; set; }
        public string LocationTypeDescription { get; set; }
        public string PhoneNumber { get; set; }
        public string GeneralFaxNumber { get; set; }
        public string MiniCommNumber { get; set; }
        public string ShopFlagDate { get; set; }
        public string SpecialistShop { get; set; }
        public string Accreditations { get; set; }
        public string ContacID { get; set; }
        public string LocalDemographicIssues { get; set; }
        public string LocalDemographicNotes { get; set; }
        public string JSPOffices { get; set; }
        public string CateringTypeID { get; set; }
        public string IsNetwork { get; set; }
        public string ClientITFacilitiesDetails { get; set; }
        public string RoomAvailability { get; set; }
        public string VolunteeringOpportunies { get; set; }
        public string OutreachLocation { get; set; }
        public string TravelDetails { get; set; }
        public string TravelNearestBus { get; set; }
        public string TravelNearestRail { get; set; }
        public string TravelNearesAirport { get; set; }
        public string LocalHotels { get; set; }
        public string VisitorParkingOnsite { get; set; }
        public string VisitorParkingSpace { get; set; }
        public string VisitorParkingAlternative { get; set; }
        public string RoomOnlyRate { get; set; }
        public string BBRate { get; set; }
        public string DDRate { get; set; }
        public string hrRate { get; set; }
        public string TeaCoffee { get; set; }
        public string Lunch { get; set; }
        public string NoOfMeetingRooms { get; set; }
        public string MeetingRoomRatePerDay { get; set; }
        public string Coding { get; set; }
        public string NegotiatedRoomOnlyRate { get; set; }
        public string BBNegotiatedRate{ get; set; }
        public string DBBNegotiatedRate{ get; set; }
        public string hrNegotiatedRate{ get; set; }
        public string LastNegotiatedDate{ get; set; }
        public string ReNegotiatedOn{ get; set; }
        public string PreferredStatus{ get; set; }
        public string Comment{ get; set; }
        public string IsActive{ get; set; }
        #region[Idata]
        public PremiseInfor MappingEntity(IDataReader dr)
        {
            PremiseInfor obj = new PremiseInfor();
            obj.AddressID = (dr["AddressID"] is DBNull ? string.Empty : dr["AddressID"].ToString());
            obj.Accreditations = (dr["Accreditations"] is DBNull ? string.Empty : dr["Accreditations"].ToString());
            obj.BBNegotiatedRate = (dr["BBNegotiatedRate"] is DBNull ? string.Empty : dr["BBNegotiatedRate"].ToString());
            obj.BBRate = (dr["BBRate"] is DBNull ? string.Empty : dr["BBRate"].ToString());
            obj.CateringTypeID = (dr["CateringTypeID"] is DBNull ? string.Empty : dr["CateringTypeID"].ToString());
            obj.CityTown = (dr["CityTown"] is DBNull ? string.Empty : dr["CityTown"].ToString());
            obj.ClientITFacilitiesDetails = (dr["ClientITFacilitiesDetails"] is DBNull ? string.Empty : dr["ClientITFacilitiesDetails"].ToString());
            obj.Coding = (dr["Coding"] is DBNull ? string.Empty : dr["Coding"].ToString());
            obj.Comment = (dr["Comment"] is DBNull ? string.Empty : dr["Comment"].ToString());
            obj.ContacID = (dr["ContacID"] is DBNull ? string.Empty : dr["ContacID"].ToString());
            obj.Country = (dr["Country"] is DBNull ? string.Empty : dr["Country"].ToString());
            obj.CountryID = (dr["CountryID"] is DBNull ? string.Empty : dr["CountryID"].ToString());
            obj.DBBNegotiatedRate = (dr["DBBNegotiatedRate"] is DBNull ? string.Empty : dr["DBBNegotiatedRate"].ToString());
            obj.DDRate = (dr["DDRate"] is DBNull ? string.Empty : dr["DDRate"].ToString());
            obj.GeneralFaxNumber = (dr["GeneralFaxNumber"] is DBNull ? string.Empty : dr["GeneralFaxNumber"].ToString());
            obj.hrNegotiatedRate = (dr["hrNegotiatedRate"] is DBNull ? string.Empty : dr["hrNegotiatedRate"].ToString());
            obj.hrRate = (dr["hrRate"] is DBNull ? string.Empty : dr["hrRate"].ToString());
            obj.IsActive = (dr["IsActive"] is DBNull ? string.Empty : dr["IsActive"].ToString());
            obj.IsNetwork = (dr["IsNetwork"] is DBNull ? string.Empty : dr["IsNetwork"].ToString());
            obj.JSPOffices = (dr["JSPOffices"] is DBNull ? string.Empty : dr["JSPOffices"].ToString());
            obj.LastNegotiatedDate = (dr["LastNegotiatedDate"] is DBNull ? string.Empty : dr["LastNegotiatedDate"].ToString());
            obj.LocalDemographicIssues = (dr["LocalDemographicIssues"] is DBNull ? string.Empty : dr["LocalDemographicIssues"].ToString());
            obj.LocalDemographicNotes = (dr["LocalDemographicNotes"] is DBNull ? string.Empty : dr["LocalDemographicNotes"].ToString());
            obj.LocalHotels = (dr["LocalHotels"] is DBNull ? string.Empty : dr["LocalHotels"].ToString());
            obj.LocationStatusDate = (dr["LocationStatusDate"] is DBNull ? string.Empty : dr["LocationStatusDate"].ToString());
            obj.LocationStatusID = (dr["LocationStatusID"] is DBNull ? string.Empty : dr["LocationStatusID"].ToString());
            obj.LocationTypeDescription = (dr["LocationTypeDescription"] is DBNull ? string.Empty : dr["LocationTypeDescription"].ToString());
            obj.LocationTypeID = (dr["LocationTypeID"] is DBNull ? string.Empty : dr["LocationTypeID"].ToString());
            obj.Lunch = (dr["Lunch"] is DBNull ? string.Empty : dr["Lunch"].ToString());
            obj.MeetingRoomRatePerDay = (dr["MeetingRoomRatePerDay"] is DBNull ? string.Empty : dr["MeetingRoomRatePerDay"].ToString());
            obj.MiniCommNumber = (dr["MiniCommNumber"] is DBNull ? string.Empty : dr["MiniCommNumber"].ToString());
            obj.NegotiatedRoomOnlyRate = (dr["NegotiatedRoomOnlyRate"] is DBNull ? string.Empty : dr["NegotiatedRoomOnlyRate"].ToString());
            obj.NoOfMeetingRooms = (dr["NoOfMeetingRooms"] is DBNull ? string.Empty : dr["NoOfMeetingRooms"].ToString());
            obj.OrgID = (dr["OrgID"] is DBNull ? string.Empty : dr["OrgID"].ToString());
            obj.OutreachLocation = (dr["OutreachLocation"] is DBNull ? string.Empty : dr["OutreachLocation"].ToString());
            obj.PhoneNumber = (dr["PhoneNumber"] is DBNull ? string.Empty : dr["PhoneNumber"].ToString());
            obj.PreferredStatus = (dr["PreferredStatus"] is DBNull ? string.Empty : dr["PreferredStatus"].ToString());
            obj.PremiseID = (dr["PremiseID"] is DBNull ? string.Empty : dr["PremiseID"].ToString());
            obj.ReNegotiatedOn = (dr["ReNegotiatedOn"] is DBNull ? string.Empty : dr["ReNegotiatedOn"].ToString());
            obj.RoomAvailability = (dr["RoomAvailability"] is DBNull ? string.Empty : dr["RoomAvailability"].ToString());
            obj.RoomOnlyRate = (dr["RoomOnlyRate"] is DBNull ? string.Empty : dr["RoomOnlyRate"].ToString());
            obj.ShopFlagDate = (dr["ShopFlagDate"] is DBNull ? string.Empty : dr["ShopFlagDate"].ToString());
            obj.SpecialistShop = (dr["SpecialistShop"] is DBNull ? string.Empty : dr["SpecialistShop"].ToString());
            obj.TeaCoffee = (dr["TeaCoffee"] is DBNull ? string.Empty : dr["TeaCoffee"].ToString());
            obj.TravelDetails = (dr["TravelDetails"] is DBNull ? string.Empty : dr["TravelDetails"].ToString());
            obj.TravelNearesAirport = (dr["TravelNearesAirport"] is DBNull ? string.Empty : dr["TravelNearesAirport"].ToString());
            obj.TravelNearestBus = (dr["TravelNearestBus"] is DBNull ? string.Empty : dr["TravelNearestBus"].ToString());
            obj.TravelNearestRail = (dr["TravelNearestRail"] is DBNull ? string.Empty : dr["TravelNearestRail"].ToString());
            obj.VisitorParkingAlternative = (dr["VisitorParkingAlternative"] is DBNull ? string.Empty : dr["VisitorParkingAlternative"].ToString());
            obj.VisitorParkingOnsite = (dr["VisitorParkingOnsite"] is DBNull ? string.Empty : dr["VisitorParkingOnsite"].ToString());
            obj.VisitorParkingSpace = (dr["VisitorParkingSpace"] is DBNull ? string.Empty : dr["VisitorParkingSpace"].ToString());
            obj.VolunteeringOpportunies = (dr["VolunteeringOpportunies"] is DBNull ? string.Empty : dr["VolunteeringOpportunies"].ToString());
            return obj;
        }
        #endregion
    }
}